/*
 * Copyright (c) 2025, 廖树财, <study_2030@163.com>
 *
 * PES1.0.3-YCYW is licensed under Mulan PSL v2.
 * You can use this software according to the terms and conditions of the Mulan PSL v2.
 * You may obtain a copy of Mulan PSL v2 at:
 *         http://license.coscl.org.cn/MulanPSL2     
 *
 * THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT, MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
 * See the Mulan PSL v2 for more details.
 */
#pragma once

char *createAlarmSql = "CREATE TABLE [alarm_rule] ([id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [ruleid] TEXT NOT NULL, [action] TEXT NOT NULL, [indicator] TEXT NOT NULL, severity TEXT NOT NULL, threshold INTEGER NOT NULL, operator TEXT NOT NULL, unit TEXT NOT NULL)";
char *selectsql = "select * from alarm_rule";
char *insertsql = "insert into alarm_rule(ruleId, action, indicator, severity, threshold, operator, unit) values("","","","","","","");";
char *deletesql = "delete from alarm_rule where ruleId = %d;"; 

int createAlarmTable();


